[dbo].[asi_GetRolesAccess]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GetRolesAccess

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@accessArea	uniqueidentifier	16

SQL Script

/****** Object: Stored Procedure dbo.asi_GetRolesAccess Script Date: 7/3/2003 4:58:03 PM ******/
CREATE PROCEDURE [dbo].[asi_GetRolesAccess]
@accessArea uniqueidentifier
AS

select ai.AccessKey, ai.Grantee, ai.Permission,
ai.RoleKey, ai.UserKey, ai.GroupKey
from AccessItem ai, AccessArea aa
where ai.AccessKey = aa.ProtectedAccessKey
and aa.AccessAreaKey = @accessArea

GO

Uses

[dbo].[AccessArea]
[dbo].[AccessItem]
dbo